EMT Practice Test

1. Question Content...

---

Question1: You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

Question2: At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

Question3: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question4: Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Question5: In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

Question6: What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

Question7: A calculation view includes a rank node that uses the source data and settings shown in the graphic.

Your query requests all columns of the rank node.How many rows are in the output of your query?

Question8: What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

Question9: Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

Question10: Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

Question11: Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

Question12: What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

Question13: You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

Question14: Using the table in the diagram, you need to create a CUBE calculation view.

What is the simplest approach to create the output shown in the screenshot?

Question15: Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

Question16: Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

Question17: Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

Question18: What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

Question19: Why would you create calculation views of data category DIMENSION with type TIME?

Question20: Why would you use the Transparent Filter property in a calculation view?

Question21: When is the first column store compression executed?

Question22: In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

Question23: What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

Question24: Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

Question25: Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

Question26: What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

Question27: You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

Question28: What is the recommended tool for developing cloud foundry applications?

Question29: Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?